INSTR(PHONE, '-') gives the index of - in the PHONE column, in your case 4 and then SUBSTR(PHONE, 1, 4 - 1) or SUBSTR(PHONE, 1, 3) ... <看更多>
Search
Search
INSTR(PHONE, '-') gives the index of - in the PHONE column, in your case 4 and then SUBSTR(PHONE, 1, 4 - 1) or SUBSTR(PHONE, 1, 3) ... <看更多>